/*
 Navicat Premium Data Transfer

 Source Server         : mengzhi
 Source Server Type    : MySQL
 Source Server Version : 50556
 Source Host           : 47.92.124.86
 Source Database       : huashan

 Target Server Type    : MySQL
 Target Server Version : 50556
 File Encoding         : utf-8

 Date: 12/13/2017 20:56:13 PM
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `account_logs`
-- ----------------------------
DROP TABLE IF EXISTS `account_logs`;
CREATE TABLE `account_logs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `member_id` int(10) unsigned DEFAULT NULL COMMENT '产生的用户',
  `type` tinyint(4) DEFAULT NULL COMMENT '1发展关系奖励2下级消费返利3注册奖励4提现5购买套餐或参与活动充值次数6后台充值7购买讲解消费',
  `price` decimal(9,2) DEFAULT NULL COMMENT '增加',
  `desc` varchar(255) DEFAULT NULL COMMENT '描述',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '修改时间',
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `member_id` (`member_id`),
  KEY `created_at` (`created_at`),
  KEY `price` (`price`),
  CONSTRAINT `account_logs_ibfk_1` FOREIGN KEY (`member_id`) REFERENCES `members` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COMMENT='账单表';

-- ----------------------------
--  Records of `account_logs`
-- ----------------------------
BEGIN;
INSERT INTO `account_logs` VALUES ('1', '6', '2', '10000.00', '推广提成', '2017-12-13 17:44:06', '2017-12-11 17:44:09', null), ('2', '6', null, '1000.00', '推广奖励', '2017-12-13 17:34:15', '2017-12-13 17:34:15', null), ('3', '32', null, '99.00', '推广奖励', '2017-12-13 17:47:50', '2017-12-13 17:47:50', null), ('4', '32', '1', '99.00', '推广奖励', '2017-12-13 17:48:25', '2017-12-13 17:48:25', null), ('5', '32', '1', '99.00', '推广奖励', '2017-12-13 18:04:50', '2017-12-13 18:04:50', null);
COMMIT;

-- ----------------------------
--  Table structure for `adseat`
-- ----------------------------
DROP TABLE IF EXISTS `adseat`;
CREATE TABLE `adseat` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `img` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  `sort` int(11) DEFAULT '50' COMMENT '排序',
  `status` varchar(255) DEFAULT NULL COMMENT '1发布2不发布',
  `created_at` varchar(255) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='广告位';

-- ----------------------------
--  Records of `adseat`
-- ----------------------------
BEGIN;
INSERT INTO `adseat` VALUES ('2', 'image/November2017/rDrt6LqGWoDtFCTXwySP.gif', '广告1', 'http://wap.baidu.com', '50', '1', '2017-11-11 12:01:22', '2017-12-04 17:01:10');
COMMIT;

-- ----------------------------
--  Table structure for `apply_devices`
-- ----------------------------
DROP TABLE IF EXISTS `apply_devices`;
CREATE TABLE `apply_devices` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `comment` varchar(100) DEFAULT NULL,
  `quantity` int(10) DEFAULT NULL,
  `apply_reason` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `apply_id` int(10) DEFAULT NULL,
  `audit_comment` varchar(255) DEFAULT NULL,
  `audit_status` smallint(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
--  Records of `apply_devices`
-- ----------------------------
BEGIN;
INSERT INTO `apply_devices` VALUES ('5', '景点', '2', '旅游', '2017-12-07 09:24:40', '2017-12-07 09:24:40', '530617', '审核中', '1'), ('6', '11', '1', '22', '2017-12-07 09:25:25', '2017-12-07 09:25:25', '530618', '审核中', '1'), ('7', '11', '1', '22', '2017-12-07 09:30:34', '2017-12-07 09:30:34', '530622', '审核中', '1'), ('8', '11', '1', '22', '2017-12-07 09:31:54', '2017-12-07 09:31:54', '530623', '审核中', '1'), ('9', '11', '1', '22', '2017-12-07 09:41:38', '2017-12-07 09:41:38', '530624', '审核中', '1');
COMMIT;

-- ----------------------------
--  Table structure for `areas`
-- ----------------------------
DROP TABLE IF EXISTS `areas`;
CREATE TABLE `areas` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sort` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `content` text,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `areas`
-- ----------------------------
BEGIN;
INSERT INTO `areas` VALUES ('1', '50', '中原区', '<p><img src=\"/storage/ueditor/php/upload/image/20171116/1510799207753545.jpg\" title=\"1510799207753545.jpg\" alt=\"u=3164822311,573063053&amp;fm=26&amp;gp=0.jpg\"/><img src=\"/storage/ueditor/php/upload/image/20171116/1510799211119771.jpg\" title=\"1510799211119771.jpg\" alt=\"u=2084862204,166370476&amp;fm=26&amp;gp=0.jpg\"/><img src=\"/storage/ueditor/php/upload/image/20171116/1510799214979557.jpg\" title=\"1510799214979557.jpg\" alt=\"ntk-1531-27503.jpg\"/><img src=\"/storage/ueditor/php/upload/image/20171116/1510799217363703.jpg\" title=\"1510799217363703.jpg\" alt=\"u=1522669257,642486458&amp;fm=23&amp;gp=0.jpg\"/>这张这张做</p>', '2017-11-09 17:11:10', '2017-11-16 10:27:03'), ('2', '50', '二七区', null, '2017-11-09 17:11:20', '2017-11-09 17:11:22'), ('3', '50', '金水区', null, '2017-11-09 17:11:34', '2017-11-09 17:11:36'), ('4', '50', '管城回族区', null, '2017-11-09 17:11:53', '2017-11-09 17:11:56'), ('5', '50', '惠济区', null, '2017-11-09 17:12:11', '2017-11-09 17:12:14'), ('6', '50', '上街区', null, '2017-11-09 17:12:45', '2017-11-09 17:12:47'), ('7', '50', '高新技术开发区', null, '2017-11-09 17:13:00', '2017-11-09 17:13:02'), ('8', '50', '经济技术开发区', null, '2017-11-09 17:13:24', '2017-11-09 17:13:27'), ('9', '50', '郑东新区', null, '2017-11-09 17:13:40', '2017-11-09 17:13:43'), ('10', '50', '航空港区', null, '2017-11-09 17:14:25', '2017-11-09 17:14:28'), ('11', '50', '荥阳市', null, '2017-11-09 17:16:06', '2017-11-09 17:16:27'), ('12', '50', '巩义市', null, '2017-11-09 17:17:27', '2017-11-09 17:17:29'), ('13', '50', '登封市', null, '2017-11-09 17:17:55', '2017-11-09 17:17:57'), ('14', '50', '新密市', null, '2017-11-09 17:18:16', '2017-11-09 17:18:18'), ('15', '50', '新郑市', null, '2017-11-09 17:18:31', '2017-11-09 17:18:55'), ('16', '50', '中牟县', null, '2017-11-09 17:19:10', '2017-11-09 17:19:12'), ('17', '1', '总概况', '<p style=\"text-align:center\"><img src=\"https://gss1.bdstatic.com/9vo3dSag_xI4khGkpoWK1HF6hhy/baike/c0%3Dbaike116%2C5%2C5%2C116%2C38/sign=38b546085a66d0166a14967af642bf62/79f0f736afc379310b3b43ece3c4b74542a911a7.jpg\" width=\"400\" height=\"556\" title=\"\" alt=\"\"/></p><p><span style=\"font-family:楷体\"></span></p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px;\"><br/></p><p><span style=\"color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px;\"></span></p><p><br/></p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\"><span style=\"font-family:楷体\"></span></p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\"><span style=\"font-family:楷体\">　编者按</span></p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-size: 18px; white-space: normal; font-family: 楷体;\"><span style=\"font-family:楷体\">　　城市是人类文明的结晶。从最初的聚居地交易场到如今的现代化大都市，“城市，让生活更美好”的主题从未改变。</span></p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-size: 18px; white-space: normal; font-family: 楷体;\"><span style=\"font-family:楷体\">　　当前，中国城市的发展模式已经从以往摊大饼式的粗放型发展，转为注重内涵的集约型发展，城市综合竞争力的评价指标从简单的GDP、人口、城市规模等转变为多层次、多维度的绿色发展指标体系。</span></p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-size: 18px; white-space: normal; font-family: 楷体;\"><span style=\"font-family:楷体\">　　一二三线城市的划分在最近10多年来一直在不断变化，“准一线城市”“新一线城市”“二线强”“二线弱”等概念层出不穷。</span></p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-size: 18px; white-space: normal; font-family: 楷体;\"><span style=\"font-family:楷体\">　　一些区位优势明显、创新能力强、人才资金流动活跃、绿色宜居的二线大城市崭露头角，直追中国城市第一方阵。</span></p><p class=\"pictext\" style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　<span style=\"color:navy\">　准一线城市争“上位”，不那么容易</span></p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　在中国城市发展竞争力的研究领域，中国社会科学院城市与竞争力研究中心连续10多年发布《中国城市竞争力报告》，评价体系也从单一的经济竞争力扩展为宜居竞争力和可持续竞争力。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　为了让读者更清晰地了解城市发展的关键要素，以及当下武汉、苏州、天津、南京、杭州、成都等“准一线城市”应如何谋求上位，本刊编辑部对中国社会科学院城市与竞争力研究中心主任倪鹏飞进行了深度访谈。</p><p class=\"pictext\" style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　<span style=\"color:navy\">　二线城市出现分野</span></p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　半月谈：</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　社会上经常出现“一二三四线城市”的提法，这个“线”有没有比较明确的共识？</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　倪鹏飞：</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　过去主要是通过行政级别、城市人口和GDP规模划分的。大概在世纪之交时，一些房地产等企业选择城市投资时，提出了市场化的分级问题。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　我曾遍查相关文献，非常有意思的是，这个“一二三四线”分级问题并没有最早的文献来源和令人信服的标准，所以，可谓是标准的现代版“传说”。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　目前，大家大致认同二线城市是计划单列市和副省级城市，以及个别经济发达的东部城市；三线城市是除计划单列市和副省级城市外的省会城市，若干经济发达的东部城市。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　半月谈：</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　北上广深这4个一线城市已经达成共识，而所谓的“准一线”或“新一线”概念的兴起，似乎说明二线城市并非一条水平线，区域性的大城市之间竞争日趋激烈。对这两个概念，您有什么看法？</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　倪鹏飞：</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　社会上出现的这两个概念，考虑了商业资源集聚度、城市枢纽性、城市人群活跃度、生活方式多样性和未来可塑性等5大指标。概念的推出具有一定背景，也反映了中国城市格局的变化，但不完全准确。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　当前，中国城市发展格局，正从单向极化即高端资源向少数高端城市聚集，转变为极化扩散，即少数高端资源向高端城市聚集，同时部分资源向次高端城市扩散。这就导致二线城市的分化。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　某些“准一线”在发展水平和单项功能上，与一线的差距日渐缩小，但在综合功能上还是有明显的差距。这是新时代的特征，也是基本现代化在城市发展格局上的反映。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　当我们实现现代化强国的时候，就能像发达国家一样，城市体系从层级关系变成网络关系，即多数城市间的发展水平基本相同，每个城市都有自己顶尖的“灵蛇之珠”专项功能，城市间功能互补性增强。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　<span style=\"color:navy\">　准一线方阵正在形成</span></p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　半月谈：</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　今年6月份，中国社科院发布了《中国城市竞争力报告2017》，2016年综合经济竞争力指数排名前10位的城市分别是深圳、香港、上海、台北、广州、天津、北京、澳门、苏州和武汉。除去港澳台，内地城市除了北上广深外，天津、苏州、武汉也位列前10，这是否说明这3座城市进入到一线城市方阵？</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　倪鹏飞：</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　中国的城市化率已经超过50%，城市格局发生了很大的变化。一些区域中心城市正向国家中心城市迈进。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　在此背景下，我认为判断准一线城市主要根据一个城市的经济中心度、金融中心度、科教中心度、交通中心度、信息中心度等综合标准。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　天津、苏州、武汉三个城市位列前10，充分说明在综合经济实力方面，已经具备了一线城市的水平。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　但另一方面，也应看到，与北上广深相比，津苏汉都有或多或少的现实差距，因此还称不上是完全的一线城市。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　除津苏汉外，还有一些城市可归为准一线城市。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　东部地区，长三角作为中国最发达也最有活力的经济区，其核心城市如杭州、南京、宁波等已经具备准一线城市的条件。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　京津冀地区则主要是天津有跻身准一线的资格。厦门、青岛、大连等城市作为各自区域城市群的中心城市也具备了准一线的条件。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　在中部，长沙、郑州也具备准一线的资格。西部则主要是成都、西安、重庆。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　半月谈：</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　从总体上看，一座城市发展的关键要素，离不开人、财、产业。那么，从这些关键要素的流向上看，您认为目前哪些准一线城市最有“上位”的潜力？</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　倪鹏飞：</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　我认为依序是杭州、苏州、武汉、成都、重庆、天津、郑州、合肥、长沙、西安、大连等。这是从关键要素的流向上看，“上位”潜力相对较好的城市。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　我重点说一下武汉。过去一年，武汉的对外交往中心和交通枢纽中心地位、区域创新型城市建设都取得了较大的进步。2016年GDP和常住人口分别位列全国第9位和第8位。在中部六省的所有城市中，武汉的综合经济竞争力、综合增量竞争力和综合效率竞争力3项均排第一位。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　之所以说武汉的潜力很大，首先在“人”的方面。近年来东部沿海地区高房价、城市拥挤等因素形成了离心力，中部地区和城市相对经济地位提升、就业居住吸引力增加，人口持续向一线城市集聚的趋势有所减弱。在此背景下，2016年武汉共增加常住人口15.85万人，并且积极落实《人才发展体制机制改革20条》，打造“大学生最友好城市”，吸引高端人才。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　第二在产业方面，中国（湖北）自由贸易试验区的获批、国务院支持武汉建设国家中心城市的政策红利，进一步巩固了武汉作为全国重要创新城市的地位。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　第三在交通方面，作为全国高铁中心、全国性铁路路网中心和长江中游航运中心城市，武汉的全国性综合交通枢纽地位日益突出。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　<span style=\"color:navy\">　治理大城市病是重中之重</span></p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　半月谈：</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　近些年，一线城市被“大城市病”困扰，准一线城市也正在或即将面临大城市病，比如产业发展不够均衡、公共资源分配不均、环境污染、可持续发展潜力不足等。您认为，准一线城市应该如何增强发展后劲、补足短板？</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　倪鹏飞：</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　克服“大城市病”是现代化城市增强发展后劲、补足短板的重中之重。国际上，城市病问题主要发生在首都地区和特大城市，而我国的城市病问题已经蔓延到许多二线城市，体现在城市人口膨胀、交通拥堵、房价高企、空气污染、社会安全弱化、就业困难等多个方面。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　规划和构建中国城市体系，除了重点发展城市群外，还应放开对大城市的限制、因地制宜发展小城镇。要构建多尺度、多中心的城市体系。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　第二，要强化大城市的规划与管理。用规划的前瞻性和科学性引领大城市健康、可持续发展。同时，完善基础设施和公共服务的供给结构，弱化拥挤效应对大城市规模经济的抵消。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　第三，对于一些人口拥挤的准一线城市，应疏散中心区的公共服务，推动公共服务的空间均衡配置，转变城市发展的空间战略，将离心疏散确立为未来主要的空间发展方向。</p><p class=\"pictext\" style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　<span style=\"color:navy\">　城市，创造价值</span></p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　半月谈：</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　目前，评价一个城市发展状况的指标有很多，中国社科院为什么要构建综合经济竞争力、宜居竞争力和可持续竞争力三大指标体系？</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　倪鹏飞：</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　总体上说，城市竞争力就是城市创造价值的能力，以及为居民提供福利的能力。这个“价值”有两层涵义，一是当前创造价值的能力，一是未来持续创造价值的能力。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　我们构建的三大指标体系中，综合经济竞争力是指当前现实的竞争力，从产出的视角，评价城市的经济规模、经济增长和综合经济效率。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　采用GDP连续5年平均增量和地均GDP来合成衡量。GDP的增量综合反映了城市收益扩展的速度及规模变动，克服了增长率在不同规模城市之间可比性较差的缺陷。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　地均GDP，严格讲是地均绿色GDP，则综合反映了单位空间上的经济收益，以及对土地这一重要资源的利用效率，也就反映了城市创造和聚集财富的效率。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　宜居竞争力主要从投入的视角考察。人的劳动和创造是一切价值的源泉，宜居竞争力决定了城市对于人才，特别是高端人才的吸引力，从而影响城市的产业体系竞争力。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　根据影响人类发展的因素框架，宜居竞争力由教育环境、医疗环境、安全环境、生态环境、居住环境、基础设施、经济环境这7个方面构成。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　可持续竞争力是指未来和潜在的竞争力。根据我们多年的研究，可持续竞争力包括经济、社会、生态、文化、城乡一体和对外开放6大方面。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\"><span style=\"color:navy\">　　“择良城终老”，何谓良城？</span></p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　半月谈：</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　人们常说“遇一人白首、择一城终老”，一座城市的好与不好，每个人都可能有其主观判断。在通往现代化强国的新征程上，现代化的城市文明可谓是题中应有之义。一座准一线大城市，应该是和谐宜居、富有活力、特色鲜明的现代化城市。如何走出一条中国特色的城市发展道路？</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　倪鹏飞：</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　择良城终老，“良城”可以体现在8个方面：</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　一是以人为本的宜居城市。以人为本是城市发展价值的出发点和落脚地。一些“空城”“鬼城”就是扭曲了这一根本价值的反面典型。在理想的宜居城市里，市民身体健康、精神愉悦、生活幸福、文明和谐；自然环境、基础设施、政府服务、私人服务的均衡化能确保大多数居民便捷、舒适的享用。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　二是创业至上的宜商城市。表现为企业的良好发展、广阔的市场需求以及优越的创业营商环境。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　三是创新驱动的知识城市。只有创新才是城市可持续发展的不竭动力。主要表现在知识经济发达，知识产业成为城市的主导产业。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　四是公平包容的和谐城市。以公平的社会制度和包容的社会精神为保障，顺畅有序运转的城市，各种社会矛盾冲突都能通过合理的机制加以解决，所有人的利益都得到了尊重和体现。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　五是环境友好的生态城市。人们的生产和生活过程被作为自然循环过程之一，低碳经济发展模式形成，生态环境建设成为城市建设的有机组成部分，人工环境与自然环境有机融为一体。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　六是多元一本的文化城市。文化是城市魅力的标志。在自由开放的社会文化吸引下，世界各地的人们来此工作、生活，为城市文化注入新的元素，城市文化画卷绚烂多彩。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　七是城乡一体的全域城市。中心城区与小城镇、乡村作为一个有机整体，在各方面共同发展，城乡居民在田园般优美的环境中享受着现代城市的优质公共服务和便利基础设施，城乡完美融合。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　八是开放便捷的信息城市。信息技术的广泛应用让城市更加“智慧”，也能汇集公众智慧，推动城市管理和服务的不断创新。</p><p class=\"pictext\" style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　<span style=\"color:navy\">　准一线城市要加紧拓展三大空间</span></p><p class=\"pictext\" style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　所谓“准一线城市”，并不是一个科学或者说有明确内涵限定的概念。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　它是一个通俗的说法，更多地见诸媒体与社会评论之中，泛指近年来风头正劲的杭州、天津、南京、武汉、苏州、成都等城市。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　它们的特征是GDP过万亿甚至接近2万亿元，人口将近千万甚至超过千万，并且城市的行政级别较高。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　准一线城市之间的竞争日趋激烈。然而，上位并非易事，意味着相互之间必然要争夺城市发展空间。这里面有两大限制因素。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　一个是一线城市的下压。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　天津要上位，受限于北京；南京、杭州是长三角副中心城市，苏州紧邻上海，它们的上位受制于上海；武汉、成都分别是长江中上游的中心城市，它们除了受到一线城市的下压，也要受“左邻右舍”合肥、长沙、南昌、重庆等城市的激烈竞争。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　往深了说，准一线、一线城市争夺的东西就是国家的空间资源、战略资源。所有期望上位的准一线城市，都是试图对国家经济地理进行重塑，都要面临一线城市以及其他准一线、二线城市有形或无形的反制。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　第二个是城市增长边界的限制。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　传统意义上的一线城市，之所以成为一线，有多种原因，但一个显著的特征就是，从经济与人口的总量规模上它们是第一阵营。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　北上广深四大城市经济总量都在2万亿至3万亿元之间，人口规模在1000万至2000万之间，分别在国家的政治、经济、开放、创新等领域占据极其显赫的地位。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　成就这些城市的，除了与国家对它们的定位有关，重要的是它们都在规模扩张年代、速度为王的时代，抢到了先机。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　现在，国际国内宏观形势发生了变化。北上广深分别提出建设用地的减量增长，而GDP的增长既要重数量更要重质量。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　这意味着未来这些城市的发展模式将发生变化，不再走平面扩张的模式，而是走创新转型的模式。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　紧随其后的准一线城市，未来也必将面临城市增长边界的限制，如果依然寄希望于通过规模扩张来超越一线城市，前景就会变得很渺茫。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　短时间来看，所谓一线、准一线城市，似乎已经形成了既定的格局。不过把时间线拉长，一二三四线城市的地位并非一成不变。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　城市地位的变化受到政治、经济、技术一系列因素的影响。城市演变发展历程表明：城市体系与格局是时代进步在特定空间上的映射。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　中国正处于一个新时代，全球化与区域化、国际化与特色化等方面的发展，为城市发展提供了前所未有的挑战与机遇——中国城市发展的空间将进一步拓展。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　这是一线城市在全球争夺领先地位的新阶段，也是准一线城市上位的窗口机遇期。对于国内的准一线城市，需要加紧拓展三大空间：</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　第一，要在城市圈发展中谋求新空间。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　未来的竞争，不是城市与城市的竞争，而是一群城市与一群城市的竞争。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　城市圈极大地扩展了大城市的空间范围，扩展了用于支撑未来发展的腹地，有利于解决大城市与周边城市、乡村发展不平衡的问题，有利于解决城市人口多样化生活需求不能充分满足的问题，有利于解决大城市病，有利于提升大城市整体竞争力。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　杭州、武汉、苏州等准一线城市在拓展城市圈方面完全可以抢得先机。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　第二，要在国家区域大战略中谋求新空间。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　京津冀协同发展、长江经济带发展、“一带一路”建设是重大国家发展战略，这些大战略是国家在空间战略上的巨大拓展，在协同开放上的重大提升。三大国家发展战略与四大板块战略相结合，构成了未来中国区域经济战略的基本框架。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　天津、南京、杭州、武汉、成都、苏州都已经是具有区域影响力的大城市，在国家战略中抢先定位、谋求发展的高地，必将为自身带来广阔的外围空间力量，有利于这些城市形成更强的国家战略意识，培育国家战略能力。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　第三，要谋划发展以信息与数据为内容的既虚拟又真实的空间。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　信息与数据，是城市新的核心发展要素。高居城市体系顶端的大城市，有的其物理空间并不是最大的，但在信息流、数据流所构成的“流”的空间上却广大无疆。这是一种空间重构，是准一线城市上位面临的巨大机遇。这方面较好的例子是杭州。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　一些准一线城市，从地域来看，周边强市林立，按传统的竞争方法，是难以从区域城市走向全国性的一线城市。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; color: rgb(64, 64, 64); font-family: &quot;PingFang SC&quot;, &quot;Lantinghei SC&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Microsoft YaHei&quot;, å¾®è½¯é›…é»‘, STHeitiSC-Light, simsun, å®‹ä½“, &quot;WenQuanYi Zen Hei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; font-size: 18px; white-space: normal;\">　　但如果这些城市能够抢抓新科技带来的机遇，迅速在物理空间上叠加出强大的数字空间，那么就能跃上一步，更加逼近城市体系的高端位置。（ 作者：冯奎，系国家发改委城市和小城镇改革发展中心研究员 来源：《半月谈》内部版第11期，原标题《准一线城市争“上位”，不那么容易》）</p><p><br/></p>', '2017-11-11 16:35:02', '2017-11-11 16:35:02');
COMMIT;

-- ----------------------------
--  Table structure for `categories`
-- ----------------------------
DROP TABLE IF EXISTS `categories`;
CREATE TABLE `categories` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `topid` int(10) unsigned DEFAULT NULL COMMENT '顶级栏目',
  `pid` int(11) unsigned DEFAULT NULL,
  `mod` tinyint(4) DEFAULT NULL COMMENT '1文章2图片3文件4视频',
  `channelid` int(11) unsigned DEFAULT NULL COMMENT '所属频道ID',
  `ispart` smallint(6) DEFAULT NULL COMMENT '栏目属性（0：最终列表栏目；1：频道封面；2：外部连接）',
  `is_default` smallint(6) DEFAULT NULL COMMENT '栏目列表选项（1：链接到默认页；0：链接到列表第一页；-1：使用动态页）',
  `corank` smallint(6) DEFAULT NULL COMMENT '浏览权限',
  `defaultname` varchar(255) DEFAULT NULL COMMENT '默认页的名称',
  `cat_name` varchar(255) DEFAULT NULL,
  `desc` varchar(255) DEFAULT NULL COMMENT '描述',
  `keywords` varchar(255) DEFAULT NULL COMMENT '关键字',
  `temparticle` varchar(255) DEFAULT NULL COMMENT '内容模板\n\n内容模板\n\n内容模板\n\n内容模板',
  `templist` varchar(255) DEFAULT NULL COMMENT '列表模板',
  `tempindex` varchar(255) DEFAULT NULL COMMENT '封面模板',
  `tpl` varchar(255) DEFAULT NULL,
  `sort` int(11) DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL COMMENT '1展示2隐藏',
  `cross` tinyint(4) DEFAULT NULL COMMENT '栏目交（0：不交叉；1：自动获取同名栏目内容；2：手工指定交叉栏目ID）',
  `crossid` int(10) unsigned DEFAULT NULL COMMENT '交叉栏目ID',
  `content` varchar(255) DEFAULT NULL COMMENT '栏目内容',
  `slug` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `slug` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8 COMMENT='栏目表';

-- ----------------------------
--  Records of `categories`
-- ----------------------------
BEGIN;
INSERT INTO `categories` VALUES ('32', '0', '0', null, null, '0', null, null, null, '旅游攻略', null, null, 'index.blade.php', 'index.blade.php', 'index.blade.php', null, '1', '1', '1', null, null, 'lygl', '2017-12-08 11:33:02', '2017-12-08 11:33:02');
COMMIT;

-- ----------------------------
--  Table structure for `combo_activities`
-- ----------------------------
DROP TABLE IF EXISTS `combo_activities`;
CREATE TABLE `combo_activities` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `sort` int(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL COMMENT '活动名称',
  `thumb` varchar(255) DEFAULT NULL COMMENT '封面',
  `type` tinyint(4) DEFAULT NULL COMMENT '活动方式1折扣2减免价格',
  `reduce` decimal(9,0) DEFAULT NULL COMMENT '减免价格',
  `rebate` float DEFAULT NULL COMMENT '折扣',
  `rate_type` tinyint(4) DEFAULT NULL COMMENT '1按套餐2自定义',
  `rate` float DEFAULT NULL COMMENT '返利',
  `top_rate` float DEFAULT NULL,
  `desc` varchar(255) DEFAULT NULL COMMENT '描述',
  `content` text COMMENT '详情',
  `start_time` datetime DEFAULT NULL COMMENT '开始时间',
  `end_time` datetime DEFAULT NULL COMMENT '结束时间',
  `status` tinyint(1) DEFAULT NULL COMMENT '是否启用1是2否',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COMMENT='促销活动表';

-- ----------------------------
--  Records of `combo_activities`
-- ----------------------------
BEGIN;
INSERT INTO `combo_activities` VALUES ('1', '50', 'huodong', 'image/December2017/ltYjiSHy7v9yNkMWHfB6.jpg', '1', '20', '20', '2', '1', '3', 'fsafas', null, '2018-01-08 17:57:23', '2018-01-09 17:57:23', '1', '2017-12-06 17:57:23', '2017-12-07 14:32:28'), ('2', '50', '活动', null, '1', '0', '1', '1', '0', '0', null, null, '2017-12-22 00:00:00', '2018-01-21 00:00:00', '2', '2017-12-13 13:52:33', '2017-12-13 13:52:33'), ('3', '50', '活动', null, '1', '0', '1', '1', '0', '0', null, null, '2017-12-22 00:00:00', '2018-01-21 00:00:00', '2', '2017-12-13 13:55:21', '2017-12-13 13:55:21'), ('4', '50', '活动名称', 'image/December2017/bJuNBwWpEC9ZCo0MR0SD.jpg', '1', '0', '89', '1', '0', '0', null, null, '2017-12-21 00:00:00', '2017-12-22 00:00:00', '2', '2017-12-13 14:41:40', '2017-12-13 14:41:40'), ('5', '50', '活动名称', 'image/December2017/bJuNBwWpEC9ZCo0MR0SD.jpg', '1', '0', '89', '1', '0', '0', null, null, '2017-12-21 00:00:00', '2017-12-22 00:00:00', '2', '2017-12-13 14:42:38', '2017-12-13 14:54:20');
COMMIT;

-- ----------------------------
--  Table structure for `combo_activities_relation`
-- ----------------------------
DROP TABLE IF EXISTS `combo_activities_relation`;
CREATE TABLE `combo_activities_relation` (
  `combo_id` int(10) unsigned DEFAULT NULL,
  `activity_id` int(10) unsigned DEFAULT NULL,
  KEY `combo_id` (`combo_id`),
  KEY `combo_activities_relation_ibfk_2` (`activity_id`),
  CONSTRAINT `combo_activities_relation_ibfk_2` FOREIGN KEY (`activity_id`) REFERENCES `combo_activities` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `combo_activities_relation_ibfk_1` FOREIGN KEY (`combo_id`) REFERENCES `combos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
--  Records of `combo_activities_relation`
-- ----------------------------
BEGIN;
INSERT INTO `combo_activities_relation` VALUES ('1', '3'), ('2', '3'), ('1', '5');
COMMIT;

-- ----------------------------
--  Table structure for `combo_orders`
-- ----------------------------
DROP TABLE IF EXISTS `combo_orders`;
CREATE TABLE `combo_orders` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `combo_id` int(10) unsigned DEFAULT NULL COMMENT '套餐id',
  `activity_id` int(10) unsigned DEFAULT NULL COMMENT '活动id',
  `member_id` int(11) unsigned DEFAULT NULL,
  `price` decimal(9,2) DEFAULT NULL COMMENT '支付价格，不是套餐价格和活动价格，为最终的支付价格。',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `combo_id` (`combo_id`),
  KEY `activity_id` (`activity_id`),
  KEY `member_id` (`member_id`),
  KEY `price` (`price`),
  CONSTRAINT `combo_orders_ibfk_2` FOREIGN KEY (`member_id`) REFERENCES `members` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `combo_orders_ibfk_1` FOREIGN KEY (`combo_id`) REFERENCES `combos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1 COMMENT='(套餐)支付订单表';

-- ----------------------------
--  Records of `combo_orders`
-- ----------------------------
BEGIN;
INSERT INTO `combo_orders` VALUES ('3', '1', null, '6', '100.00', '2017-12-11 11:16:38', '2017-12-11 16:57:44', '2017-12-11 17:03:37'), ('4', '2', null, '13', '350.00', '2017-12-13 15:03:13', null, null), ('5', '2', null, '6', '56.00', '2018-02-15 15:03:31', null, null), ('6', '1', null, '13', '120.00', '2017-12-11 13:08:17', '2017-12-11 15:26:48', null);
COMMIT;

-- ----------------------------
--  Table structure for `combos`
-- ----------------------------
DROP TABLE IF EXISTS `combos`;
CREATE TABLE `combos` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL COMMENT '套餐名称',
  `thumb` varchar(255) DEFAULT NULL COMMENT '套餐封面',
  `price` decimal(9,2) NOT NULL DEFAULT '0.00' COMMENT '价格',
  `times` int(11) NOT NULL DEFAULT '0' COMMENT '包含次数',
  `desc` varchar(255) DEFAULT NULL COMMENT '描述',
  `content` text COMMENT '详情',
  `rate_type` tinyint(255) DEFAULT NULL COMMENT '1.按系统设置2.自定义',
  `rate` float NOT NULL DEFAULT '0' COMMENT '返利比率',
  `top_rate` float DEFAULT NULL,
  `sort` int(11) DEFAULT NULL,
  `status` tinyint(4) DEFAULT NULL COMMENT '是否上架1是2否',
  `updated_at` datetime DEFAULT NULL COMMENT '修改时间',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='套餐表';

-- ----------------------------
--  Records of `combos`
-- ----------------------------
BEGIN;
INSERT INTO `combos` VALUES ('1', '测试套餐', 'image/December2017/0RZN09QSfyxx2h7kpAuH.jpg', '80.00', '10', '描述', '<table width=\"95%\" align=\"center\"><tbody><tr class=\"firstRow\"><td style=\"line-height: 18px; word-wrap: break-word;\"><p><span style=\"color:#ff0000\">创建修改栏目时，有很多小提示因此不对每项功能进行一一详细介绍，在这里列出几个注意事项：</span><br/>1、增加栏目时最基本的设置填写栏目名称和选择栏目所属的内容模型，此外还需要注意文件保存目录的选项，内容模型是指栏目属于文章、图集、下载等类型或自定义的内容类型，文件保存目录在没有填写的情况下系统会自动使用栏目名称的拼音作为栏目目录；<br/>2、栏目属性：决定当前栏目是普通的多页列表还是单个封面页或跳转到其它网址的链接；<br/>3、栏目交叉：栏目交叉是指一个大栏目与另一个非下级的子栏目出现交叉的情况，相当于系统原来的副栏目功能，不过现在改在栏目里预先设置好。<br/>例如： 网站上有大栏目——智能手机、音乐手机，另外又有栏目——诺基亚-&gt;智能手机、诺基亚-&gt;音乐手机，这样顶级的大栏目就和另一个大栏目的子栏目形成了交叉，这样只需要在大栏目中指定交叉的栏目即可。&nbsp;<em>(注：会自动索引交叉栏目的内容，但不会索引交叉栏目下级栏目的内容，这种应用也适用于按地区划分资讯的站点。)</em>&nbsp;<br/>4、绑定域名的设置：被绑定域名指向当前栏目目录为绑定域名的根目录，只有顶级栏目才能绑定域名，开启了栏目的二级域名还需要修改系统参数“是/否)支持多站点，开启此项后附件、栏目连接、arclist内容启用绝对网址：”改为“是”。<br/>5、栏目模板、栏目生成的HTML和栏目文档的HTML的命名规则都是可以手工指定的，可以在高级参数中填写这个选项。<br/>6、栏目内容，对于大多数据栏目而言，这一项可以不需要填写，通常如果用于公司简介等简单页面，可以直接在栏目里填写内容，栏目模板中用{dede:field.content/}调用。<br/>7、快速创建栏目——如果你不需要设置复杂的栏目参数，可以用快速创建栏目的模式创建二级的栏目，当然如果你要创建更深层次的目录，则必须单独创建。</p></td></tr></tbody></table><p><br/></p>', '1', '0', '0', '1', '1', '2017-12-06 15:04:31', '2017-12-06 15:04:31'), ('2', '100元包干价', 'image/December2017/5gwY50CN5N7yzUDxWPNk.jpg', '100.00', '120', null, null, '2', '20', '2', '1', '1', '2017-12-08 11:22:11', '2017-12-08 11:22:11');
COMMIT;

-- ----------------------------
--  Table structure for `devices`
-- ----------------------------
DROP TABLE IF EXISTS `devices`;
CREATE TABLE `devices` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `apply_id` int(10) DEFAULT NULL,
  `comment` varchar(255) DEFAULT NULL,
  `device_id` int(10) DEFAULT NULL,
  `major` int(10) DEFAULT NULL,
  `minor` int(10) DEFAULT NULL,
  `status` smallint(1) DEFAULT NULL,
  `last_active_time` varchar(255) DEFAULT NULL,
  `poi_id` int(10) DEFAULT NULL,
  `uuid` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `page_id` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
--  Records of `devices`
-- ----------------------------
BEGIN;
INSERT INTO `devices` VALUES ('6', '530624', '44', '18655427', '10174', '63560', '0', '0', '0', 'FDA50693-A4E2-4FB1-AFCF-C6EB07647825', null, '2017-12-08 10:08:35', '6506675');
COMMIT;

-- ----------------------------
--  Table structure for `game_configs`
-- ----------------------------
DROP TABLE IF EXISTS `game_configs`;
CREATE TABLE `game_configs` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `game_id` int(10) DEFAULT NULL,
  `prize_id` int(10) DEFAULT NULL,
  `level` int(1) DEFAULT NULL,
  `chance` int(3) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `color` varchar(100) DEFAULT NULL COMMENT '颜色排序',
  `name` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
--  Records of `game_configs`
-- ----------------------------
BEGIN;
INSERT INTO `game_configs` VALUES ('1', '1', '2', '3', '30', '2017-12-11 15:57:23', '2017-12-13 10:45:52', '[1,2,3]', '出现一次红包'), ('2', '1', '1', '4', '60', '2017-12-12 17:36:08', '2017-12-12 09:38:59', '[1,2,3]', '出现两次红包'), ('3', '1', '1', '3', '11', '2017-12-12 17:36:04', '2017-12-13 10:46:05', '[3,3,3]', '出现三次红包');
COMMIT;

-- ----------------------------
--  Table structure for `game_prize_records`
-- ----------------------------
DROP TABLE IF EXISTS `game_prize_records`;
CREATE TABLE `game_prize_records` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `user_id` int(10) DEFAULT NULL,
  `game_id` int(10) DEFAULT NULL,
  `prize_id` varchar(200) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
--  Records of `game_prize_records`
-- ----------------------------
BEGIN;
INSERT INTO `game_prize_records` VALUES ('1', '32', '1', '1', '2017-12-12 11:21:49', '2017-12-12 11:21:49'), ('2', '32', '1', '1', '2017-12-12 15:30:14', '2017-12-12 15:30:14'), ('3', '32', '1', '1', '2017-12-12 15:30:21', '2017-12-12 15:30:21'), ('4', '32', '1', '1', '2017-12-12 15:30:27', '2017-12-12 15:30:27'), ('5', '32', '1', '1', '2017-12-12 15:30:28', '2017-12-12 15:30:28'), ('6', '32', '1', '1', '2017-12-12 15:30:34', '2017-12-12 15:30:34'), ('7', '32', '1', '1', '2017-12-12 15:30:40', '2017-12-12 15:30:40');
COMMIT;

-- ----------------------------
--  Table structure for `game_prizes`
-- ----------------------------
DROP TABLE IF EXISTS `game_prizes`;
CREATE TABLE `game_prizes` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `game_id` int(10) DEFAULT NULL,
  `type` int(10) DEFAULT NULL COMMENT '奖品类型',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `value` varchar(200) DEFAULT NULL,
  `name` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
--  Records of `game_prizes`
-- ----------------------------
BEGIN;
INSERT INTO `game_prizes` VALUES ('1', '1', '0', '2017-12-12 10:31:39', null, '3', '赠送景区三次'), ('2', '1', null, '2017-12-12 17:21:47', '2017-12-12 17:22:42', '3', '赠送景点3次');
COMMIT;

-- ----------------------------
--  Table structure for `games`
-- ----------------------------
DROP TABLE IF EXISTS `games`;
CREATE TABLE `games` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) DEFAULT NULL,
  `rule` varchar(255) DEFAULT NULL COMMENT '规则',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
--  Records of `games`
-- ----------------------------
BEGIN;
INSERT INTO `games` VALUES ('1', '老虎机', '规则', null, null);
COMMIT;

-- ----------------------------
--  Table structure for `members`
-- ----------------------------
DROP TABLE IF EXISTS `members`;
CREATE TABLE `members` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `pid` int(10) unsigned NOT NULL DEFAULT '0',
  `path` varchar(255) NOT NULL DEFAULT '0' COMMENT '代系树，如id为1的用户没有推广人则为0,1；id为2的用户推广人是1则为0,1,2',
  `nickname` varchar(255) DEFAULT NULL,
  `headimgurl` varchar(255) DEFAULT NULL,
  `sex` tinyint(4) DEFAULT NULL COMMENT '1男2女',
  `age` int(11) DEFAULT NULL COMMENT '年龄',
  `country` varchar(50) DEFAULT NULL COMMENT '国家',
  `province` varchar(50) DEFAULT NULL COMMENT '省',
  `city` varchar(50) DEFAULT NULL COMMENT '市',
  `area` varchar(50) DEFAULT NULL COMMENT '区',
  `address` varchar(50) DEFAULT NULL COMMENT '详细地址',
  `mobile` varchar(255) DEFAULT NULL,
  `openid` varchar(255) DEFAULT NULL,
  `wallet_all_push_money` decimal(9,2) NOT NULL DEFAULT '0.00' COMMENT '总提成',
  `wallet_used_push_money` decimal(9,2) NOT NULL DEFAULT '0.00' COMMENT '已使用的提成',
  `wallet_push_money` decimal(9,2) NOT NULL DEFAULT '0.00' COMMENT '剩余提成',
  `wallet_withdraw` decimal(9,2) NOT NULL DEFAULT '0.00' COMMENT '提现金额',
  `wallet_spots` int(11) NOT NULL DEFAULT '0' COMMENT '剩余景点次数',
  `consume` tinyint(4) NOT NULL DEFAULT '2' COMMENT '是否产生消费1是2否',
  `subscribe` tinyint(4) DEFAULT NULL COMMENT '用户是否订阅该公众号标识，值为0时，代表此用户没有关注该公众号，拉取不到其余信息。',
  `status` tinyint(4) DEFAULT '1' COMMENT '1启用2禁用',
  `created_at` datetime DEFAULT NULL COMMENT '注册时间',
  `updated_at` datetime DEFAULT NULL COMMENT '修改时间',
  `game_num` int(11) DEFAULT '0' COMMENT '游戏剩余次数',
  PRIMARY KEY (`id`),
  KEY `created_at` (`created_at`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8 COMMENT='用户表';

-- ----------------------------
--  Records of `members`
-- ----------------------------
BEGIN;
INSERT INTO `members` VALUES ('6', '0', '0,6', 'layer', 'http://wx.qlogo.cn/mmopen/vi_32/DYAIOgq83eoNd9xThPE6gZds22sY5zxNEy22vEn1wcvwELGgIeVqfamYazayKJIv4ySlUIuicn1kiagBPYwZY2nA/0', '1', null, '中国', '河南', '郑州', null, null, null, '2BLxIwOi5A5BJM7Do', '1149.00', '0.00', '1119.00', '0.00', '0', '2', '1', '1', '2017-12-08 13:44:14', '2017-12-13 17:40:25', '0'), ('8', '0', '0,8', '勇敢的心', 'http://wx.qlogo.cn/mmopen/vi_32/DYAIOgq83eoW63kUFCfRktph0fYOfvpRia80oxBNMr5icYibDocFB5akCmGDRpzk25UcSib6PGSGU0IooJI5ufziabQ/0', '1', null, '中国', '河南', '安阳', null, null, null, 'oA00lwDXi3ctoX2_eBvzWz7HccwU', '0.00', '0.00', '0.00', '0.00', '0', '2', '1', '1', '2017-12-08 15:43:50', '2017-12-08 15:43:50', '0'), ('13', '0', '0,13', '清月曦', 'http://wx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTKIgE33HuBN3LwiaruoFNATBkR9dNQIZGHydsoKqm3icoMeTttLj2anDcBC72kejiakl6WYYoVt4tNSA/0', '1', null, '安道尔', '', '', null, null, null, 'oA00lwLaV5uP8zcG62cVDZPMk6_s', '0.00', '0.00', '0.00', '0.00', '0', '2', '1', '1', '2017-12-08 15:53:41', '2017-12-08 15:53:41', '0'), ('19', '6', '0,6,19', '丫丫', 'http://wx.qlogo.cn/mmopen/vi_32/IYaqXv0tyFqkoMEE640rUwZ1sRueMzRcHdzjZSpwcutJgBW66uWnravUpYgOM4GJW2sc3c6CpibIcbcIBBezRjw/0', '1', null, '中国', '河南', '郑州', null, null, null, 'oA00lwPWml6bCs4CWGnmglUeMvqE', '0.00', '0.00', '0.00', '0.00', '0', '2', '1', '1', '2017-12-08 16:16:30', '2017-12-08 16:16:31', '0'), ('27', '19', '0,6,19,27', 'Hariini', 'http://wx.qlogo.cn/mmopen/RLjFTwTqFiaF7sZEWqIwzYZBz1Wj4W8d2gSMNu80Lwyib6zXZ7K9oxlOtyLnsFXZ6DEHQbZT68hc9UO3S2ozNug0bMx8WNodYu/0', '1', null, '中国', '河南', '南阳', null, null, null, 'oA00lwKuQc9rN4ReFh9ocou_bqX8', '0.00', '0.00', '0.00', '0.00', '0', '2', '1', '1', '2017-12-08 17:43:23', '2017-12-08 17:43:23', '0'), ('28', '19', '0,6,19,28', '常彬海', 'http://wx.qlogo.cn/mmopen/PiajxSqBRaEIcMkOYdIT0kEGu5vec5JA4UDW6YmfdpUOppTicLK10A1fQR3Zpl1iczfJIIAUXmLgcGJz0OfzAia54w/0', '1', null, '中国', '河南', '郑州', null, null, null, 'oA00lwIZakm2D6VhNYrmvHQbYQwo', '0.00', '0.00', '0.00', '0.00', '0', '2', '1', '1', '2017-12-08 17:43:41', '2017-12-08 17:43:41', '0'), ('31', '19', '0,6,19,31', '张学义', 'http://wx.qlogo.cn/mmopen/k0qQoMjmC7NtjedBcszSIlH4z1aEib1Ep9aW80vsCNlQq6If6aVichEmFbSXKq5x79vFjLNVWJa0zC28JVbucojLhibP4deaFnK/0', '1', null, '中国', '河南', '郑州', null, null, null, 'oA00lwKLUGSHs_y4imPH7TiuFRvw', '0.00', '0.00', '0.00', '0.00', '0', '2', '1', '1', '2017-12-08 17:45:28', '2017-12-08 17:45:28', '0'), ('32', '19', '0,6,19,32', 'layer', 'http://wx.qlogo.cn/mmopen/k0qQoMjmC7NdrMbb56icqbiaBw4ibicMmdaDyZZFMjcDqXWzq2wG4H7BkLVXRXo8AIob2W41Jj1g5FvIZGLBuzFibbA/0', '1', null, '中国', '河南', '郑州', null, null, null, 'oA00lwIQMP42BLxIwOi5A5BJM7Do', '594.00', '0.00', '594.00', '0.00', '21', '2', '1', '1', '2017-12-08 17:50:17', '2017-12-13 18:04:50', '0'), ('33', '19', '0,6,19,33', '刘国超', 'http://wx.qlogo.cn/mmopen/PiajxSqBRaEKibffQiatQ0HytV39dLL3RQretolyHYp0LRLZCc43uCTV1dSxzlP4EibGoqF5kxyKGicjicricewK6x2Ww/0', '1', null, '中国', '河南', '郑州', null, null, null, 'oA00lwM-KxgtAtWY4W4TGbyDCxpo', '0.00', '0.00', '0.00', '0.00', '0', '2', '1', '1', '2017-12-08 17:51:39', '2017-12-08 17:51:40', '0'), ('34', '19', '0,6,19,34', '痕', 'http://wx.qlogo.cn/mmopen/jDeAQwkqQfThv73KIo8jC31ZCUibJcbYibNrTs2pLibY99vBqwUBheNlWIgf61plBA1QibqDkZv0vqnWiaP09In3V2qOMWLK8vvcic/0', '1', null, '中国', '河南', '漯河', null, null, null, 'oA00lwEar348mNm8GxzCFcCmpbSw', '0.00', '0.00', '0.00', '0.00', '0', '2', '1', '1', '2017-12-09 17:54:36', '2017-12-08 17:54:37', '0'), ('43', '32', '0,6,19,32,43', '充满正义感的某某某　　　    　༽', 'http://wx.qlogo.cn/mmopen/vDwntJFbiafsVcOibNG3au9US9sYs3lsBEzoMg5Ekp31KsWQ8MkiaGgoxBE8mcoiaceMsv1HibWltycia2AeXbibsmELw/0', '1', null, '中国', '河南', '郑州', null, null, null, 'oA00lwMrQQJkRv5xibtebPMPCV0I', '0.00', '0.00', '0.00', '0.00', '0', '2', null, '1', '2017-12-13 18:04:50', '2017-12-13 18:04:50', '0');
COMMIT;

-- ----------------------------
--  Table structure for `menus`
-- ----------------------------
DROP TABLE IF EXISTS `menus`;
CREATE TABLE `menus` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `title` varchar(250) DEFAULT NULL,
  `icon` varchar(250) DEFAULT NULL,
  `href` varchar(250) DEFAULT NULL,
  `parent_id` int(10) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `permission` varchar(100) DEFAULT NULL,
  `order` int(10) DEFAULT '0' COMMENT '排序',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `menus`
-- ----------------------------
BEGIN;
INSERT INTO `menus` VALUES ('1', '管理员管理', 'fa-users', null, '0', '2017-10-24 21:27:00', '2017-12-05 16:44:28', 'user_index', '50'), ('2', '管理员列表', 'fa-user', '/admin/user/index', '1', '2017-10-24 21:27:50', null, 'user_index', '0'), ('3', '角色管理', 'fa-group', '/admin/role/index', '1', '2017-10-24 21:30:16', null, 'role_index', '0'), ('9', '系统设置', 'fa-cogs', null, '0', '2017-10-27 16:10:46', '2017-12-05 16:44:29', 'setting', '50'), ('10', '网站设置', 'fa-cog', '/admin/setting', '9', '2017-10-27 16:11:52', null, 'setting', '1'), ('11', '微站管理', 'fa-sitemap', null, '0', '2017-11-06 12:01:43', null, 'wap', '1'), ('13', '文章列表', 'fa-file-text', '/admin/posts', '11', '2017-11-06 12:03:12', null, 'posts', '1'), ('15', '地区管理', 'fa-map-marker', '/admin/area', '9', '2017-11-11 13:51:34', '2017-11-29 11:28:17', 'setting', '3'), ('16', '文章栏目', 'fa-list', '/admin/categories', '11', '2017-11-11 15:48:05', '2017-11-11 15:48:07', 'posts', '4'), ('20', '开发者工具', 'fa-wrench', null, '0', '2017-11-27 15:10:44', '2017-12-05 16:44:34', 'admin', '50'), ('21', '菜单管理', 'fa-list', '/admin/dev-menu', '20', '2017-11-27 15:16:55', '2017-11-29 09:27:39', 'admin', '1'), ('22', '权限管理', 'fa-key', '/admin/permission', '20', '2017-11-27 15:17:36', null, 'admin', '2'), ('27', '景区介绍', 'fa fa-cloud', '/admin/scene/introduce', '11', '2017-12-05 15:50:39', '2017-12-05 18:03:26', 'wap', '1'), ('28', '景点维护', 'fa fa-bank', '', '0', '2017-12-05 16:14:21', '2017-12-05 16:44:35', 'scene', '2'), ('29', '景点管理', 'fa fa-cloud', '/admin/scene/spot', '28', '2017-12-05 16:26:18', '2017-12-06 11:00:00', 'scene', '1'), ('30', '设备管理', 'fa fa-link', '/admin/device', '28', '2017-12-05 16:30:04', '2017-12-05 16:30:04', 'scene', '2'), ('31', '营销管理', 'fa fa-shopping-cart', '', '0', '2017-12-05 16:42:14', '2017-12-05 16:44:36', 'combo', '3'), ('32', '套餐管理', 'fa fa-stack-overflow', '/admin/business/combo', '31', '2017-12-05 16:47:00', '2017-12-06 14:21:55', 'combo', '50'), ('33', '促销活动', 'fa fa-star fa-spin', '/admin/business/comboActivities', '31', '2017-12-05 16:49:37', '2017-12-06 15:45:36', 'combo', '50'), ('34', '支付记录', 'fa fa-bookmark-o', '/admin/business/comboOrder', '31', '2017-12-05 16:52:18', '2017-12-07 09:18:24', 'combo', '50'), ('35', '用户管理', 'fa fa-user-md', '', '0', '2017-12-05 16:53:39', '2017-12-05 16:53:49', 'member', '4'), ('36', '用户列表', 'fa fa-users', '/admin/member/member', '35', '2017-12-05 16:54:58', '2017-12-07 16:12:03', 'member', '50'), ('37', '充值记录', 'fa fa-plug', '/admin/member/recharge', '35', '2017-12-05 17:07:10', '2017-12-08 15:46:22', 'member', '50'), ('38', '报表与统计', 'fa fa-line-chart', '', '0', '2017-12-05 17:07:56', '2017-12-05 17:08:07', 'report', '6'), ('39', '销售统计', 'fa fa-jpy', '/admin/report/sale', '38', '2017-12-05 17:09:16', '2017-12-11 10:47:56', 'report', '50'), ('40', '景点统计', 'fa fa-cloud', '/admin/report/spot', '38', '2017-12-05 17:10:05', '2017-12-12 11:54:47', 'report', '50'), ('41', '分销统计', 'fa fa-sitemap', '/admin/report/distribute', '38', '2017-12-05 17:12:09', '2017-12-12 11:55:53', 'report', '50'), ('42', '游戏管理', 'fa fa-sitemap', null, null, null, null, 'game', '5'), ('43', '奖品设置', 'fa fa-sitemap', '/admin/game/prize', '42', null, null, 'game', '0'), ('44', '游戏设置', 'fa fa-sitemap', '/admin/game/index', '42', null, null, 'game', '0'), ('45', '游戏管理', 'fa-gamepad', '', '0', '2017-12-12 16:28:20', '2017-12-12 16:28:20', 'game', '4'), ('46', '奖品设置', 'fa-gamepad', '/admin/prize', '45', '2017-12-12 16:29:57', '2017-12-12 16:29:57', 'game', '50'), ('47', '游戏设置', 'fa-gamepad', '/admin/game/', '45', '2017-12-12 16:30:44', '2017-12-12 16:30:44', 'game', '50'), ('48', '中奖纪录', 'fa-angellist', '/admin/game/record', '45', '2017-12-13 10:48:35', '2017-12-13 13:59:30', 'game', '50');
COMMIT;

-- ----------------------------
--  Table structure for `migrations`
-- ----------------------------
DROP TABLE IF EXISTS `migrations`;
CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
--  Records of `migrations`
-- ----------------------------
BEGIN;
INSERT INTO `migrations` VALUES ('1', '2014_10_12_000000_create_users_table', '1'), ('2', '2014_10_12_100000_create_password_resets_table', '1'), ('3', '2017_10_17_114444_create_permission_tables', '2'), ('4', '2017_11_13_110210_modify_wx_material', '3');
COMMIT;

-- ----------------------------
--  Table structure for `model_has_permissions`
-- ----------------------------
DROP TABLE IF EXISTS `model_has_permissions`;
CREATE TABLE `model_has_permissions` (
  `permission_id` int(10) unsigned NOT NULL,
  `model_id` int(10) unsigned NOT NULL,
  `model_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
--  Records of `model_has_permissions`
-- ----------------------------
BEGIN;
INSERT INTO `model_has_permissions` VALUES ('1', '1', 'App\\User');
COMMIT;

-- ----------------------------
--  Table structure for `model_has_roles`
-- ----------------------------
DROP TABLE IF EXISTS `model_has_roles`;
CREATE TABLE `model_has_roles` (
  `role_id` int(10) unsigned NOT NULL,
  `model_id` int(10) unsigned NOT NULL,
  `model_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
--  Records of `model_has_roles`
-- ----------------------------
BEGIN;
INSERT INTO `model_has_roles` VALUES ('3', '1', 'App\\User'), ('3', '2', 'App\\User'), ('4', '3', 'App\\User'), ('3', '804', 'App\\User');
COMMIT;

-- ----------------------------
--  Table structure for `nav`
-- ----------------------------
DROP TABLE IF EXISTS `nav`;
CREATE TABLE `nav` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `group_id` int(10) unsigned DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  `icon` varchar(255) DEFAULT NULL,
  `type` tinyint(4) DEFAULT NULL COMMENT '1文章链接2栏目链接3url链接',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `group_id` (`group_id`),
  CONSTRAINT `nav_ibfk_1` FOREIGN KEY (`group_id`) REFERENCES `nav_group` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='导航';

-- ----------------------------
--  Records of `nav`
-- ----------------------------
BEGIN;
INSERT INTO `nav` VALUES ('1', '1', '新闻动态', 'xwdt', '/code/images/icon1.png', '2', '2017-11-10 11:27:50', '2017-11-10 11:27:52'), ('2', '1', '人才政策', 'rczc', '/code/images/icon2.png', '2', '2017-11-10 11:28:34', '2017-11-10 11:28:37'), ('3', '1', '常见问题', 'cjwt', '/code/images/icon3.png', '2', '2017-11-10 11:28:54', '2017-11-10 11:28:56'), ('4', '1', '郑州发展', 'zzfz', '/code/images/icon4.png', '2', '2017-11-10 11:29:24', '2017-11-10 11:29:26'), ('5', '2', '首页', '/', 'mui-sprite-home', '3', '2017-11-10 14:04:05', '2017-11-10 14:04:07'), ('6', '2', '人才政策', 'rczc', 'mui-sprite-class', '2', '2017-11-10 14:04:57', '2017-11-10 14:04:59'), ('7', '2', '常见问题', 'cjwt', 'mui-sprite-order', '2', '2017-11-10 14:05:32', '2017-11-10 14:05:34');
COMMIT;

-- ----------------------------
--  Table structure for `nav_group`
-- ----------------------------
DROP TABLE IF EXISTS `nav_group`;
CREATE TABLE `nav_group` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='导航组';

-- ----------------------------
--  Records of `nav_group`
-- ----------------------------
BEGIN;
INSERT INTO `nav_group` VALUES ('1', '主菜单', '2017-11-10 11:25:02', '2017-11-10 11:25:04'), ('2', '底部菜单', '2017-11-10 14:02:45', '2017-11-10 14:02:47');
COMMIT;

-- ----------------------------
--  Table structure for `password_resets`
-- ----------------------------
DROP TABLE IF EXISTS `password_resets`;
CREATE TABLE `password_resets` (
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
--  Table structure for `permissions`
-- ----------------------------
DROP TABLE IF EXISTS `permissions`;
CREATE TABLE `permissions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `desc` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `group_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
--  Records of `permissions`
-- ----------------------------
BEGIN;
INSERT INTO `permissions` VALUES ('1', 'login', 'web', '2017-10-24 10:03:46', '2017-10-24 10:03:46', '登录', '后台管理'), ('2', 'modify_password', 'web', '2017-10-24 10:16:09', '2017-10-24 10:16:13', '修改密码', '后台管理'), ('6', 'user_edit', 'web', '2017-10-24 15:21:17', null, '修改个人信息', '会员管理'), ('7', 'user_index', 'web', '2017-10-24 22:04:51', null, '用户列表', '会员管理'), ('8', 'role_index', 'web', '2017-10-24 21:56:02', null, '角色列表', '角色管理'), ('11', 'user_add', 'web', '2017-10-25 11:35:47', null, '增加用户', '会员管理'), ('12', 'user_detail', 'web', '2017-10-25 11:46:21', null, '查看信息', '会员管理'), ('13', 'role_add', 'web', '2017-10-25 16:31:18', null, '增加角色', '角色管理'), ('14', 'role_edit', 'web', '2017-10-25 16:31:48', null, '编辑角色', '角色管理'), ('15', 'role_permission', 'web', '2017-10-25 16:32:57', null, '角色授权', '角色管理'), ('16', 'role_del', 'web', '2017-10-25 16:33:36', null, '删除角色', '角色管理'), ('25', 'setting', 'web', '2017-10-27 16:08:58', null, '网站设置', '系统设置'), ('27', 'posts', 'web', '2017-11-06 13:44:20', null, '文章', '文章管理'), ('28', 'adseat', 'web', '2017-11-11 10:41:43', '2017-11-11 10:41:45', '广告位', '广告位管理'), ('29', 'wap', 'web', '2017-11-11 10:42:58', '2017-11-11 10:43:07', '微站管理', '微站管理'), ('31', 'wx', 'web', '2017-11-13 11:28:13', '2017-11-13 11:28:15', '微信管理', '微信管理'), ('32', 'admin', 'web', '2017-11-27 15:26:35', '2017-11-27 15:26:37', '开发者工具', '开发者工具'), ('33', 'sys', 'web', '2017-11-29 11:21:00', '2017-11-29 11:21:00', '系统管理', '系统设置'), ('34', 'scene', 'web', '2017-12-05 15:53:34', '2017-12-05 15:53:34', '景点、设备权限', '景点信息维护'), ('35', 'combo', 'web', '2017-12-05 15:57:07', '2017-12-05 15:57:07', '套餐管理、促销活动、等营销信息', '套餐相关'), ('36', 'member', 'web', '2017-12-05 16:02:28', '2017-12-05 16:02:28', '用户相关', '用户相关'), ('37', 'report', 'web', '2017-12-05 16:10:19', '2017-12-05 16:10:19', '报表统计', '报表统计'), ('38', 'device_index', 'web', '2017-12-06 10:05:31', null, '设备列表', '设备管理'), ('39', 'comboAllOrder', 'web', '2017-12-07 09:25:50', '2017-12-07 09:25:50', '查看所有套餐购买记录、隐藏购买记录', '套餐相关'), ('40', 'game', 'web', '2017-12-12 16:03:00', '2017-12-12 16:03:04', '游戏管理', '游戏管理');
COMMIT;

-- ----------------------------
--  Table structure for `posts`
-- ----------------------------
DROP TABLE IF EXISTS `posts`;
CREATE TABLE `posts` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` int(11) unsigned DEFAULT NULL,
  `is_recommend` tinyint(1) DEFAULT NULL,
  `sort` int(11) NOT NULL DEFAULT '50' COMMENT '排序',
  `source` varchar(255) DEFAULT NULL COMMENT '来源',
  `post_title` varchar(255) DEFAULT NULL,
  `digest` varchar(255) DEFAULT NULL,
  `thumb` varchar(255) DEFAULT NULL,
  `wx_content` text,
  `content` text,
  `file` text,
  `tpl` varchar(255) DEFAULT NULL,
  `status` tinyint(4) DEFAULT NULL COMMENT '1：草稿 2：发布',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `cat_id` (`category_id`),
  CONSTRAINT `posts_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `posts`
-- ----------------------------
BEGIN;
INSERT INTO `posts` VALUES ('30', '32', '1', '2', '', '华山一日游必备攻略', '', 'image/December2017/v5qzyFl2tGCZ5YYFcVHw.jpg', null, '', null, 'index.blade.php', '1', '2017-12-08 11:33:41', '2017-12-08 15:27:29'), ('32', '32', '2', '1', '', '华山出行须知', '', '', null, '', null, '', '2', '2017-12-08 11:34:44', '2017-12-08 15:27:19');
COMMIT;

-- ----------------------------
--  Table structure for `role_has_permissions`
-- ----------------------------
DROP TABLE IF EXISTS `role_has_permissions`;
CREATE TABLE `role_has_permissions` (
  `permission_id` int(10) unsigned NOT NULL,
  `role_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`),
  CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
--  Records of `role_has_permissions`
-- ----------------------------
BEGIN;
INSERT INTO `role_has_permissions` VALUES ('1', '3'), ('2', '3'), ('6', '3'), ('7', '3'), ('8', '3'), ('11', '3'), ('12', '3'), ('13', '3'), ('14', '3'), ('15', '3'), ('16', '3'), ('25', '3'), ('27', '3'), ('28', '3'), ('29', '3'), ('31', '3'), ('32', '3'), ('33', '3'), ('34', '3'), ('35', '3'), ('36', '3'), ('37', '3'), ('38', '3'), ('39', '3'), ('40', '3'), ('1', '4'), ('2', '4'), ('35', '4');
COMMIT;

-- ----------------------------
--  Table structure for `roles`
-- ----------------------------
DROP TABLE IF EXISTS `roles`;
CREATE TABLE `roles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
--  Records of `roles`
-- ----------------------------
BEGIN;
INSERT INTO `roles` VALUES ('3', '管理员', 'web', '2017-10-24 11:28:14', '2017-10-24 11:28:14'), ('4', '景区管理员', 'web', '2017-12-07 14:41:08', '2017-12-07 14:41:08');
COMMIT;

-- ----------------------------
--  Table structure for `scene_introduce`
-- ----------------------------
DROP TABLE IF EXISTS `scene_introduce`;
CREATE TABLE `scene_introduce` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `logo` varchar(255) DEFAULT NULL,
  `desc` varchar(255) DEFAULT NULL,
  `content` text,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
--  Records of `scene_introduce`
-- ----------------------------
BEGIN;
INSERT INTO `scene_introduce` VALUES ('1', 'image/December2017/TEV3uYHwDjh4TzqZl0qM.jpg', 'fffff', '<table width=\"95%\" align=\"center\"><tbody><tr class=\"firstRow\"><td style=\"line-height: 18px; word-wrap: break-word;\"><p><span style=\"color:#ff0000\">创建修改栏目时，有很多小提示因此不对每项功能进行一一详细介绍，在这里列出几个注意事项：</span><br/>1、增加栏目时最基本的设置填写栏目名称和选择栏目所属的内容模型，此外还需要注意文件保存目录的选项，内容模型是指栏目属于文章、图集、下载等类型或自定义的内容类型，文件保存目录在没有填写的情况下系统会自动使用栏目名称的拼音作为栏目目录；<br/>2、栏目属性：决定当前栏目是普通的多页列表还是单个封面页或跳转到其它网址的链接；<br/>3、栏目交叉：栏目交叉是指一个大栏目与另一个非下级的子栏目出现交叉的情况，相当于系统原来的副栏目功能，不过现在改在栏目里预先设置好。<br/>例如： 网站上有大栏目——智能手机、音乐手机，另外又有栏目——诺基亚-&gt;智能手机、诺基亚-&gt;音乐手机，这样顶级的大栏目就和另一个大栏目的子栏目形成了交叉，这样只需要在大栏目中指定交叉的栏目即可。&nbsp;<em>(注：会自动索引交叉栏目的内容，但不会索引交叉栏目下级栏目的内容，这种应用也适用于按地区划分资讯的站点。)</em>&nbsp;<br/>4、绑定域名的设置：被绑定域名指向当前栏目目录为绑定域名的根目录，只有顶级栏目才能绑定域名，开启了栏目的二级域名还需要修改系统参数“是/否)支持多站点，开启此项后附件、栏目连接、arclist内容启用绝对网址：”改为“是”。<br/>5、栏目模板、栏目生成的HTML和栏目文档的HTML的命名规则都是可以手工指定的，可以在高级参数中填写这个选项。<br/>6、栏目内容，对于大多数据栏目而言，这一项可以不需要填写，通常如果用于公司简介等简单页面，可以直接在栏目里填写内容，栏目模板中用{dede:field.content/}调用。<br/>7、快速创建栏目——如果你不需要设置复杂的栏目参数，可以用快速创建栏目的模式创建二级的栏目，当然如果你要创建更深层次的目录，则必须单独创建。</p></td></tr></tbody></table><p><br/></p>', '2017-12-06 10:21:02', '2017-12-06 10:21:07');
COMMIT;

-- ----------------------------
--  Table structure for `scenic`
-- ----------------------------
DROP TABLE IF EXISTS `scenic`;
CREATE TABLE `scenic` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL COMMENT '景点名称',
  `voice` varchar(255) DEFAULT NULL COMMENT '音频(以url形式)',
  `thumb` varchar(255) DEFAULT NULL COMMENT '封面',
  `desc` varchar(255) DEFAULT NULL COMMENT '描述',
  `content` text COMMENT '文字叙述',
  `sort` int(11) DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL COMMENT '1启用2禁用',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '修改时间',
  `page_id` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COMMENT='景点';

-- ----------------------------
--  Records of `scenic`
-- ----------------------------
BEGIN;
INSERT INTO `scenic` VALUES ('8', '华山', 'voice/201712/8196ca8285c57399a9b4f273bbf3fd0a.mp3', 'image/December2017/awCfXgoZG2Sru4SElyK2.jpg', '嘿嘿', '<p>敖德萨多<br/></p>', '50', '1', '2017-12-07 16:22:22', '2017-12-08 11:31:43', '6506675'), ('9', '华山入口处', 'voice/201712/71270c3d104b48023a484eaf05f0c6ef.mp3', 'image/December2017/qnsWuefaRra3wCgDTfQg.jpg', null, null, '1', '1', '2017-12-12 12:00:53', '2017-12-12 12:00:53', null);
COMMIT;

-- ----------------------------
--  Table structure for `scenic_buy`
-- ----------------------------
DROP TABLE IF EXISTS `scenic_buy`;
CREATE TABLE `scenic_buy` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `scenic` int(10) unsigned DEFAULT NULL COMMENT '景点id、当查询用户是否拥有该景点讲解试听权也可以通过此表',
  `member_id` int(10) unsigned DEFAULT NULL,
  `spot` int(11) NOT NULL DEFAULT '1' COMMENT '价格默认为1，为了防止有免费赠送类型的',
  `desc` varchar(255) DEFAULT NULL COMMENT '描述说明：如xx景点讲解消费||新用户注册景点赠送',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `member_id` (`member_id`),
  KEY `scenic` (`scenic`),
  CONSTRAINT `scenic_buy_ibfk_1` FOREIGN KEY (`member_id`) REFERENCES `members` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `scenic_buy_ibfk_2` FOREIGN KEY (`scenic`) REFERENCES `scenic` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='用户购买景点表';

-- ----------------------------
--  Records of `scenic_buy`
-- ----------------------------
BEGIN;
INSERT INTO `scenic_buy` VALUES ('2', '8', '6', '1', '购买景点', '2017-12-12 11:41:42', '2017-12-12 11:41:44');
COMMIT;

-- ----------------------------
--  Table structure for `settings`
-- ----------------------------
DROP TABLE IF EXISTS `settings`;
CREATE TABLE `settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) DEFAULT NULL,
  `value` text,
  `group` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `desc` varchar(100) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `order` int(10) DEFAULT NULL,
  `helper` varchar(255) DEFAULT NULL,
  `options` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `settings`
-- ----------------------------
BEGIN;
INSERT INTO `settings` VALUES ('2', 'title', '华山电子导游', '网站设置', '2017-11-07 15:09:20', '2017-12-05 16:14:38', '网站名称', 'text', null, null, null), ('3', 'admin-logo', 'image/December2017/kDDBLiKRxLVvFFoCUMrZ.jpg', '网站设置', '2017-11-07 15:10:05', '2017-12-08 10:55:15', '后台Logo', 'image', null, null, null), ('4', 'icon', 'image/November2017/SCTYNNeGi59npqAuzoPM.png', '网站设置', '2017-11-07 15:12:55', '2017-11-07 16:55:29', '页面导标', 'image', null, null, null), ('5', 'keywords', '智慧 智汇郑州 郑州 智汇 便民', 'SEO优化', '2017-11-07 15:15:32', '2017-11-07 15:15:35', 'Keywords', 'text', null, null, null), ('6', 'description', '智汇郑州，情系郑州', 'SEO优化', '2017-11-07 15:16:23', '2017-11-07 15:16:24', 'Description', 'text', null, null, null), ('7', 'logo', 'image/November2017/V9y5BMruoVeqw0ftpqJ3.png', 'Wap设置', '2017-11-07 15:19:48', '2017-11-07 17:00:09', '手机端Logo', 'image', null, null, null), ('8', 'ICP', '豫xxxxxx', '网站设置', '2017-11-07 15:20:34', '2017-11-07 15:20:36', '备案号', 'text', null, null, null), ('9', 'open', '1', 'Wap设置', '2017-11-07 15:22:04', '2017-11-07 15:22:07', '是否开启', 'text', null, null, null), ('13', 'rate', '20', '分销设置', '2017-12-07 11:26:30', '2017-12-07 11:26:33', '上级比率', 'text', null, '当套餐选择按系统返利时生效', ''), ('14', 'topRate', '3', '分销设置', '2017-12-07 11:30:52', '2017-12-07 11:30:55', '顶级比率', 'text', null, '当套餐选择按系统返利时生效', null), ('15', 'sceneId', '8', '网站设置', '2017-12-12 13:52:45', '2017-12-12 14:15:20', '试听讲解', 'text', null, '请填写试听的景点id', null), ('16', 'distributeWay', '1', '分销设置', '2017-12-12 13:55:34', '2017-12-13 17:25:22', '推广奖励', 'radio', null, null, '[\"用户完成第一笔消费\",\"用户关注\",\"无奖励\"]'), ('17', 'distributeMoney', '99', '分销设置', '2017-12-12 14:07:33', '2017-12-13 17:25:23', '奖励金额', 'text', null, '每完成一个推广对推广者的奖励（提成金额）', null), ('18', 'regAward', '1', '分销设置', '2017-12-12 14:12:50', '2017-12-12 14:15:21', '完善信息奖励', 'text', null, '用户完善信息的奖励(景点次数)', null);
COMMIT;

-- ----------------------------
--  Table structure for `users`
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `avatar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `display_writing` int(1) DEFAULT '1' COMMENT '是否屏蔽作品',
  `allow_login` int(1) DEFAULT '1' COMMENT '0禁止登陆  1允许登陆',
  `allow_comment` int(1) DEFAULT '1' COMMENT '禁止评论',
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
--  Records of `users`
-- ----------------------------
BEGIN;
INSERT INTO `users` VALUES ('1', 'admin', '13526738157@163.com', '$2y$10$VOubfn5JQhUW8UypEpaXQuARWEE3z8qZRH4T2CHtzTPWKe.P9ZZK2', 'RaAGWdch2reIJDkNDP3jVaZDZ6OmMPez9rsCeG2S6s5AYoswQ3no57mpZjRG', '2017-10-17 10:10:42', '2017-12-08 10:54:46', 'image/December2017/biyqOnLmsOGQTCK4etxI.jpg', '1', '1', '1'), ('2', 'xu', 'xu@123.com', '$2y$10$BK6jyjIoN/GaXWpjqNfMjO3j5WhyvB1guwyY5DqHhicLm2AzAnapy', 'qhWKlijgkUBXTnUmnsLMjWAzxUWUi1OzZ7nNfqZstQN0Rb5jjZ2APOG9DqBe', '2017-12-04 11:49:58', '2017-12-04 11:49:58', 'image/December2017/Z5jqIfJEFNGmafUlrGHZ.jpg', '1', '1', '1'), ('3', '景区管理员1', 'hs01@hs.com', '$2y$10$I7l3mgMNaJ84x..zyD.0f.VpxuJXgfUMM.vg8dGoxTw3GekEmvtPG', 'cLFL0SDwkTeJD3IPdk8xvI5uBrVtQbkQP9Jpd8nJtfVcXJqNT1LG9wRdZtyB', '2017-12-07 14:36:15', '2017-12-07 14:36:15', 'image/December2017/CrXCEiwpaM05UFtk7JYx.jpg', '1', '1', '1');
COMMIT;

-- ----------------------------
--  Table structure for `wx_material`
-- ----------------------------
DROP TABLE IF EXISTS `wx_material`;
CREATE TABLE `wx_material` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `image_count` int(11) DEFAULT NULL COMMENT '图片数量',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `wx_material_image`
-- ----------------------------
DROP TABLE IF EXISTS `wx_material_image`;
CREATE TABLE `wx_material_image` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `media_id` varchar(255) DEFAULT NULL COMMENT '媒体id',
  `url` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL COMMENT '图片原文件名',
  `update_time` bigint(20) DEFAULT NULL COMMENT '微信的更新时间',
  `created_at` timestamp NULL DEFAULT NULL COMMENT '系统创建时间',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT '系统更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `wx_material_image`
-- ----------------------------
BEGIN;
INSERT INTO `wx_material_image` VALUES ('1', 'w5UhFURxnpaVSAvlOcyfOsFYvnYzxJWRYzH7acKYE7k', null, 'VVQxbTPbSPPAlX2FvunJ.png', null, '2017-11-15 14:49:02', '2017-11-15 14:49:05'), ('2', 'w5UhFURxnpaVSAvlOcyfOpfakjWioJ3apTqLJufQffc', null, 'IC1gpeplp7ZhEGgPkNAr.jpg', null, '2017-11-15 14:50:15', '2017-11-15 14:50:17'), ('3', 'w5UhFURxnpaVSAvlOcyfOpc21LXj-ko1UYE3i2pMy5c', null, 'qiuofv9YXHKGoZ5ALpuc.jpg', null, '2017-11-15 14:50:10', '2017-11-15 14:50:12'), ('4', 'w5UhFURxnpaVSAvlOcyfOhOutLEHkgs8zo2-DxlA_z4', 'http://mmbiz.qpic.cn/mmbiz_jpg/3Ry7JV1aiaBYDBJAkBsA36YWUEhHicFJZ2jUlWib5ia0N64avXZiaCyLQicL8axArbBXaOAPkdLlWJ5kgUF1RpakuN1Q/0?wx_fmt=jpeg', 'image/November2017/fm5hu0Tyn8ZHanYphCvq.jpg', null, '2017-11-15 16:04:11', '2017-11-15 16:04:11'), ('5', 'w5UhFURxnpaVSAvlOcyfOpnmd5XENHiS5SicDwDIWCA', 'http://mmbiz.qpic.cn/mmbiz_png/3Ry7JV1aiaBYDBJAkBsA36YWUEhHicFJZ2EfZE60JQUwjka7G2icaum2WYwy12yZeaXthP0fxj1qpHOOml5tjZPDg/0?wx_fmt=png', 'image/November2017/zqU8ErLWGfpM41pjxZSI.png', null, '2017-11-15 16:09:41', '2017-11-15 16:09:41'), ('6', 'w5UhFURxnpaVSAvlOcyfOgqxvuuEj02nthlWyHnYuP0', 'http://mmbiz.qpic.cn/mmbiz_jpg/3Ry7JV1aiaBZ6l0htE7BcMkJWMLJCKqWh1Iln8UIoJsoquXn9oewRQbTjOg3dbX0AFRPOtsOajwILibdmSTa7qMQ/0?wx_fmt=jpeg', 'image/November2017/Za0hAqFyTtOJJlv9vpHO.jpg', null, '2017-11-16 11:09:58', '2017-11-16 11:09:58'), ('7', 'w5UhFURxnpaVSAvlOcyfOpRtwisJcwTBX7mZX2WFaVo', 'http://mmbiz.qpic.cn/mmbiz_png/3Ry7JV1aiaBZ6l0htE7BcMkJWMLJCKqWhTxkqqQiazgWmyJPtlJCWXS1QbiaZJIa0myocAsyzyCfIuibXb6iaib2CsFg/0?wx_fmt=png', 'image/November2017/a3J5bizhv9O5ajLEgZlX.png', null, '2017-11-16 13:45:06', '2017-11-16 13:45:06'), ('8', 'w5UhFURxnpaVSAvlOcyfOrvl2gWKCSZyakBQvFTqEpQ', null, null, null, '2017-11-16 13:45:07', '2017-11-16 13:45:07'), ('9', 'w5UhFURxnpaVSAvlOcyfOhIrLqcMFa2ZZKjwIoZujyo', null, null, null, '2017-11-16 14:26:34', '2017-11-16 14:26:34');
COMMIT;

-- ----------------------------
--  Table structure for `wx_material_news`
-- ----------------------------
DROP TABLE IF EXISTS `wx_material_news`;
CREATE TABLE `wx_material_news` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `media_id` int(11) DEFAULT NULL COMMENT '媒体id',
  `update_time` bigint(20) DEFAULT NULL COMMENT '微信更新时间',
  `created_at` timestamp NULL DEFAULT NULL COMMENT '系统创建时间',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT '系统更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `wx_send_log`
-- ----------------------------
DROP TABLE IF EXISTS `wx_send_log`;
CREATE TABLE `wx_send_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `media_id` varchar(255) DEFAULT NULL,
  `type` varchar(4) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `wx_send_news_content`
-- ----------------------------
DROP TABLE IF EXISTS `wx_send_news_content`;
CREATE TABLE `wx_send_news_content` (
  `id` int(11) NOT NULL,
  `log_id` int(10) unsigned DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `author` varchar(255) DEFAULT NULL,
  `digest` varchar(255) DEFAULT NULL,
  `content_source_url` varchar(255) DEFAULT NULL,
  `thumb_media_id` varchar(255) DEFAULT NULL,
  `show_cover_pic` tinyint(4) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `thumb_url` varchar(255) DEFAULT NULL,
  `need_open_comment` tinyint(4) DEFAULT NULL,
  `only_fans_can_comment` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `log_id` (`log_id`),
  CONSTRAINT `wx_send_news_content_ibfk_1` FOREIGN KEY (`log_id`) REFERENCES `wx_send_log` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

SET FOREIGN_KEY_CHECKS = 1;
